[dbo].[SystemRef]

Property	Value
Created	10:31:40 AM Tuesday, March 02, 2010
Last Modified	11:40:08 AM Monday, February 20, 2012

Property

Value

Created

10:31:40 AM Tuesday, March 02, 2010

Last Modified

11:40:08 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
SystemKeyword	nvarchar(25)	50
SystemName	nvarchar(50)	100
SystemDescription	nvarchar(250)	500
SystemKey	uniqueidentifier	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

SystemKeyword

nvarchar(25)

SystemName

nvarchar(50)

100

SystemDescription

nvarchar(250)

500

SystemKey

uniqueidentifier

	Name	Columns	Unique
	PK_SystemRef	SystemKeyword
	AK_SystemRef_SystemKey	SystemKey

Name

Columns

Unique

PK_SystemRef

SystemKeyword

AK_SystemRef_SystemKey

SystemKey

SQL Script

CREATE TABLE [dbo].[SystemRef]
(
[SystemKeyword] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SystemName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SystemDescription] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SystemKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[SystemRef] ADD CONSTRAINT [PK_SystemRef] PRIMARY KEY CLUSTERED ([SystemKeyword]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [AK_SystemRef_SystemKey] ON [dbo].[SystemRef] ([SystemKey]) ON [PRIMARY]
GO